﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="testdetailview.aspx.cs" Inherits="test_testdetailview" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server" Text="测试查询界面及功能" Width="400px"></asp:Label><br />
        <br />
        <br />
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:greenbelt_zxdConnectionString2 %>"
            SelectCommand="SELECT * FROM [fzd] WHERE (([bm] = 'kecheng') AND ([type] <>'NULL'))">
        </asp:SqlDataSource><asp:SqlDataSource ID="zxdDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:greenbelt_zxdConnectionString2 %>"
            SelectCommand="SELECT [value] FROM [nzd] WHERE ([type] = @type)"></asp:SqlDataSource>
                <SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList2" Name="type" PropertyName="SelectedValue"
                        Type="String" />
                </SelectParameters>       
        <asp:SqlDataSource ID="zxdDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:greenbelt_zxdConnectionString2 %>"
            SelectCommand="SELECT [fenlei1], [fenlei2], [fenlei3], [name] FROM [kecheng] WHERE ([fenlei1] = @fenlei1)">
                <SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList2" Name="fenlei1" PropertyName="SelectedValue"
                        Type="String" />
                </SelectParameters>
            </asp:SqlDataSource>
        <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
            DataTextField="remark" DataValueField="type">
        </asp:DropDownList><br />
        <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2"
            DataTextField="value" DataValueField="value">
        </asp:DropDownList><br />
        <br />
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource3">
            <Columns>
                <asp:CommandField ShowSelectButton="True" />
                <asp:BoundField DataField="fenlei1" HeaderText="fenlei1" SortExpression="fenlei1" />
                <asp:BoundField DataField="fenlei2" HeaderText="fenlei2" SortExpression="fenlei2" />
                <asp:BoundField DataField="fenlei3" HeaderText="fenlei3" SortExpression="fenlei3" />
                <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
            </Columns>
        </asp:GridView>
    
    </div>
    </form>
</body>
</html>
